EIFlashWork

Logical Entity Name | EIFlashWork
Default Table Name | EIFlashWork
Physical Only | NO
Owner | dbo
Definition |
Note |

EIFlashWork Columns

ColumnName | Domain | Datatype | NULL | Definition
EIFlashWorkID |  | int | NO |
Type |  | char(2) | YES |
Title |  | char(50) | YES |
LWeek1 |  | int | YES |
LMTD1 |  | int | YES |
LYTD1 |  | int | YES |
EWeek1 |  | int | YES |
EMTD1 |  | int | YES |
EYTD1 |  | int | YES |
SWeek1 |  | int | YES |
SMTD1 |  | int | YES |
SYTD1 |  | int | YES |
RWeek1 |  | int | YES |
RMTD1 |  | int | YES |
RYTD1 |  | int | YES |
LeadsWeek2 |  | int | YES |
ApptsWeek2 |  | int | YES |
InterWeek2 |  | int | YES |
EnrollWeek2 |  | int | YES |
LeadsMTD2 |  | int | YES |
ApptsMTD2 |  | int | YES |
InterMTD2 |  | int | YES |
EnrollMTD2 |  | int | YES |
RepType2 |  | char(40) | YES |
Percent3 |  | int | YES |
BudStart3 |  | int | YES |
OrigEnroll3 |  | int | YES |
Cancel3 |  | int | YES |
NoShow3 |  | int | YES |
FaAwardLetter3 |  | int | YES |
Month14 |  | int | YES |
Month24 |  | int | YES |
Month34 |  | int | YES |
Month44 |  | int | YES |
Month54 |  | int | YES |
Month64 |  | int | YES |
Month74 |  | int | YES |
Month84 |  | int | YES |
Month94 |  | int | YES |
Month104 |  | int | YES |
Month114 |  | int | YES |
Month124 |  | int | YES |
Month134 |  | int | YES |
Month1A4 |  | char(3) | YES |
Month2A4 |  | char(3) | YES |
Month3A4 |  | char(3) | YES |
Month4A4 |  | char(3) | YES |
Month5A4 |  | char(3) | YES |
Month6A4 |  | char(3) | YES |
Month7A4 |  | char(3) | YES |
Month8A4 |  | char(3) | YES |
Month9A4 |  | char(3) | YES |
Month10A4 |  | char(3) | YES |
Month11A4 |  | char(3) | YES |
Month12A4 |  | char(3) | YES |
Month13A4 |  | char(15) | YES |
PackStatus4 |  | char(15) | YES |
WBegPop5 |  | int | YES |
MBegPop5 |  | int | YES |
YBegPop5 |  | int | YES |
WNewStarts5 |  | int | YES |
MNewStarts5 |  | int | YES |
YNewStarts5 |  | int | YES |
WReStarts5 |  | int | YES |
MReStarts5 |  | int | YES |
YReStarts5 |  | int | YES |
WTranIn5 |  | int | YES |
MTranIn5 |  | int | YES |
YTranIn5 |  | int | YES |
WTranOut5 |  | int | YES |
MTranOut5 |  | int | YES |
YTranOut5 |  | int | YES |
WDrops5 |  | int | YES |
MDrops5 |  | int | YES |
YDrops5 |  | int | YES |
WLoa5 |  | int | YES |
MLoa5 |  | int | YES |
YLoa5 |  | int | YES |
WSPN5 |  | int | YES |
MSPN5 |  | int | YES |
YSPN5 |  | int | YES |
WIncomplete5 |  | int | YES |
MIncomplete5 |  | int | YES |
YIncomplete5 |  | int | YES |
WGrad5 |  | int | YES |
MGrad5 |  | int | YES |
YGrad5 |  | int | YES |
WComplete5 |  | int | YES |
MComplete5 |  | int | YES |
YComplete5 |  | int | YES |
WEndPop5 |  | int | YES |
MEndPop5 |  | int | YES |
YEndPop5 |  | int | YES |
WeekEnding |  | datetime | YES |
DateAdded |  | datetime | YES |
DateLstMod |  | datetime | YES |
UserID |  | int | YES |
CampusName |  | char(60) | YES |
ts |  | timestamp | NO |

EIFlashWork Primary and Unique Keys

Key Name | Key Type | Keys
EIFlashWork_EIFlashWorkID_U_C_IDX | PrimaryKey | EIFlashWorkID

EIFlashWork Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication

EIFlashWork Check Constraints

Check Constraint Name | CheckConstraint

EIFlashWork Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

EIFlashWork Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.EIFlashWork | NO |  |  |
Physical (Microsoft SQL Server) dbo.EIFlashWork | NO |  |  |

EIFlashWork Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model

EIFlashWork Data Movement Rules

Name | Type | Rule Text/Value